explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fbDw : 2

Settings
# exclusive inclusive rows x rows loops node
1. 6.385 10.335 ↑ 3.2 7,072 1

Gather (cost=1,033.84..192,800.45 rows=22,840 width=686) (actual time=1.447..10.335 rows=7,072 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 2.211 3.950 ↑ 3.8 3,536 2 / 2

Nested Loop (cost=33.84..189,516.45 rows=13,435 width=686) (actual time=0.250..3.950 rows=3,536 loops=2)

  • Join Filter: (account_entry.operation_id = document_acc_entry_template.operation_id)
3. 0.330 0.855 ↑ 4.3 221 2 / 2

Nested Loop (cost=33.40..13,668.10 rows=942 width=563) (actual time=0.212..0.855 rows=221 loops=2)

4. 0.162 0.304 ↑ 4.3 221 2 / 2

Parallel Bitmap Heap Scan on account_entry (cost=32.98..6,327.19 rows=942 width=364) (actual time=0.169..0.304 rows=221 loops=2)

  • Recheck Cond: (document_id = 12,302,819)
  • Heap Blocks: exact=59
5. 0.142 0.142 ↑ 1.2 1,373 1 / 2

Bitmap Index Scan on account_entry_document_id (cost=0.00..32.58 rows=1,601 width=0) (actual time=0.284..0.284 rows=1,373 loops=1)

  • Index Cond: (document_id = 12,302,819)
6. 0.221 0.221 ↑ 1.0 1 442 / 2

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)
7. 0.884 0.884 ↑ 5.1 16 442 / 2

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.002..0.004 rows=16 loops=442)

  • Index Cond: (operation_id = document_operations.id)
Planning time : 1.317 ms
Execution time : 10.711 ms