explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6iAs : 1

Settings
# exclusive inclusive rows x rows loops node
1. 1,744.643 15,120.941 ↑ 15,375.4 336 1

Gather (cost=1,390,935.38..3,868,130.94 rows=5,166,146 width=1,777) (actual time=13,614.557..15,120.941 rows=336 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 3,583.108 13,376.298 ↑ 19,839.3 84 4 / 4

Parallel Hash Join (cost=1,389,935.38..3,350,516.34 rows=1,666,499 width=1,777) (actual time=13,375.988..13,376.298 rows=84 loops=4)

  • Hash Cond: (account_entry.operation_id = document_operations.id)
3. 0.084 0.098 ↑ 23,432.6 5 4 / 4

Parallel Bitmap Heap Scan on account_entry (cost=6,803.41..978,000.96 rows=117,163 width=507) (actual time=0.097..0.098 rows=5 loops=4)

  • Recheck Cond: (document_id = 11,578,575)
  • Heap Blocks: exact=1
4. 0.014 0.014 ↑ 6,372.0 57 1 / 4

Bitmap Index Scan on account_entry_document_id (cost=0.00..6,712.61 rows=363,206 width=0) (actual time=0.055..0.055 rows=57 loops=1)

  • Index Cond: (document_id = 11,578,575)
5. 4,921.656 9,793.092 ↑ 1.3 4,739,573 4 / 4

Parallel Hash (cost=339,183.24..339,183.24 rows=6,115,578 width=1,270) (actual time=9,793.092..9,793.092 rows=4,739,573 loops=4)

  • Buckets: 262,144 Batches: 128 Memory Usage: 48,160kB
6. 3,902.601 4,871.436 ↑ 1.3 4,739,573 4 / 4

Parallel Hash Join (cost=49,372.01..339,183.24 rows=6,115,578 width=1,270) (actual time=357.296..4,871.436 rows=4,739,573 loops=4)

  • Hash Cond: (document_acc_entry_template.operation_id = document_operations.id)
7. 615.661 615.661 ↑ 1.3 4,739,573 4 / 4

Parallel Seq Scan on document_acc_entry_template (cost=0.00..273,757.78 rows=6,115,578 width=625) (actual time=0.032..615.661 rows=4,739,573 loops=4)

8. 279.217 353.174 ↑ 1.3 333,222 4 / 4

Parallel Hash (cost=43,997.56..43,997.56 rows=429,956 width=645) (actual time=353.167..353.174 rows=333,222 loops=4)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 335,680kB
9. 73.957 73.957 ↑ 1.3 333,222 4 / 4

Parallel Seq Scan on document_operations (cost=0.00..43,997.56 rows=429,956 width=645) (actual time=0.032..73.957 rows=333,222 loops=4)

Planning time : 2.073 ms
Execution time : 15,121.143 ms