explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gogq : 6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.028 ↓ 0.0 0 1

Hash Join (cost=2,343,735.50..5,404,276.61 rows=5,162,304 width=1,777) (actual time=0.028..0.028 rows=0 loops=1)

  • Hash Cond: (account_entry.operation_id = document_acc_entry_template.operation_id)
2. 0.001 0.028 ↓ 0.0 0 1

Hash Join (cost=185,824.99..1,317,102.89 rows=362,825 width=1,152) (actual time=0.027..0.028 rows=0 loops=1)

  • Hash Cond: (account_entry.operation_id = document_operations.id)
3. 0.011 0.027 ↓ 0.0 0 1

Bitmap Heap Scan on account_entry (cost=6,800.46..980,308.95 rows=362,825 width=507) (actual time=0.027..0.027 rows=0 loops=1)

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

Bitmap Index Scan on account_entry_document_id (cost=0.00..6,709.76 rows=362,825 width=0) (actual time=0.016..0.016 rows=78 loops=1)

  • Index Cond: (document_id = 11,578,575)
5. 0.000 0.000 ↓ 0.0 0

Hash (cost=53,026.68..53,026.68 rows=1,332,868 width=645) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on document_operations (cost=0.00..53,026.68 rows=1,332,868 width=645) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash (cost=402,243.56..402,243.56 rows=18,964,156 width=625) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on document_acc_entry_template (cost=0.00..402,243.56 rows=18,964,156 width=625) (never executed)

Planning time : 1.065 ms
Execution time : 0.179 ms