explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S5JT : 3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 12,864.243 ↓ 0.0 0 1

Merge Join (cost=9,592,355.54..10,008,182.43 rows=5,159,489 width=1,777) (actual time=12,864.243..12,864.243 rows=0 loops=1)

  • Merge Cond: (document_operations.id = account_entry.operation_id)
2. 0.014 12,864.187 ↑ 18,958,292.0 1 1

Merge Join (cost=8,578,710.65..8,869,749.47 rows=18,958,292 width=1,270) (actual time=12,864.187..12,864.187 rows=1 loops=1)

  • Merge Cond: (document_acc_entry_template.operation_id = document_operations.id)
3. 6,567.813 11,054.222 ↑ 18,958,292.0 1 1

Sort (cost=8,007,401.63..8,054,797.36 rows=18,958,292 width=625) (actual time=11,054.222..11,054.222 rows=1 loops=1)

  • Sort Key: document_acc_entry_template.operation_id
  • Sort Method: external merge Disk: 1,341,832kB
4. 4,486.409 4,486.409 ↑ 1.0 18,958,291 1

Seq Scan on document_acc_entry_template (cost=0.00..402,184.92 rows=18,958,292 width=625) (actual time=0.423..4,486.409 rows=18,958,291 loops=1)

5. 1,239.531 1,809.951 ↑ 1,332,889.0 1 1

Sort (cost=571,309.02..574,641.24 rows=1,332,889 width=645) (actual time=1,809.951..1,809.951 rows=1 loops=1)

  • Sort Key: document_operations.id
  • Sort Method: external merge Disk: 286,984kB
6. 570.420 570.420 ↑ 1.0 1,332,889 1

Seq Scan on document_operations (cost=0.00..53,026.89 rows=1,332,889 width=645) (actual time=0.588..570.420 rows=1,332,889 loops=1)

7. 0.007 0.054 ↓ 0.0 0 1

Sort (cost=1,013,644.89..1,014,551.75 rows=362,745 width=507) (actual time=0.054..0.054 rows=0 loops=1)

  • Sort Key: account_entry.operation_id
  • Sort Method: quicksort Memory: 25kB
8. 0.017 0.047 ↓ 0.0 0 1

Bitmap Heap Scan on account_entry (cost=6,799.84..980,147.94 rows=362,745 width=507) (actual time=0.047..0.047 rows=0 loops=1)

  • Recheck Cond: (document_id = 11,578,575)
  • Heap Blocks: exact=4
9. 0.030 0.030 ↑ 4,650.6 78 1

Bitmap Index Scan on account_entry_document_id (cost=0.00..6,709.15 rows=362,745 width=0) (actual time=0.030..0.030 rows=78 loops=1)

  • Index Cond: (document_id = 11,578,575)
Planning time : 0.861 ms
Execution time : 13,324.649 ms