explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7DiN : 4

Settings
# exclusive inclusive rows x rows loops node
1. 4.055 7.217 ↑ 3.2 7,072 1

Nested Loop (cost=1.43..317,642.87 rows=22,840 width=686) (actual time=0.129..7.217 rows=7,072 loops=1)

  • Join Filter: (account_entry.operation_id = document_acc_entry_template.operation_id)
2. 0.609 1.394 ↑ 3.6 442 1

Nested Loop (cost=0.99..18,775.35 rows=1,601 width=563) (actual time=0.112..1.394 rows=442 loops=1)

3. 0.343 0.343 ↑ 3.6 442 1

Index Scan using account_entry_document_id on account_entry (cost=0.57..6,298.90 rows=1,601 width=364) (actual time=0.078..0.343 rows=442 loops=1)

  • Index Cond: (document_id = 12,302,819)
4. 0.442 0.442 ↑ 1.0 1 442

Index Scan using document_operations_pkey on document_operations (cost=0.43..7.79 rows=1 width=199) (actual time=0.001..0.001 rows=1 loops=442)

  • Index Cond: (id = account_entry.operation_id)
5. 1.768 1.768 ↑ 5.1 16 442

Index Scan using document_acc_entry_template_operation_id on document_acc_entry_template (cost=0.44..185.66 rows=81 width=123) (actual time=0.001..0.004 rows=16 loops=442)

  • Index Cond: (operation_id = document_operations.id)
Planning time : 1.158 ms
Execution time : 7.524 ms