explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VQe

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.124 ↓ 0.0 0 1

HashAggregate (cost=38.98..40.28 rows=104 width=158) (actual time=0.124..0.124 rows=0 loops=1)

  • Group Key: dt2.doc_type_name, de.doc_type_id, mm.supplier_contract_id
2. 0.000 0.122 ↓ 0.0 0 1

Hash Join (cost=28.56..37.94 rows=104 width=129) (actual time=0.122..0.122 rows=0 loops=1)

  • Hash Cond: (de.doc_type_id = dt2.doc_type_id)
3. 0.001 0.122 ↓ 0.0 0 1

Hash Join (cost=6.41..14.48 rows=104 width=11) (actual time=0.122..0.122 rows=0 loops=1)

  • Hash Cond: (mm.doc_edit_id = de.doc_edit_id)
4. 0.038 0.121 ↓ 0.0 0 1

Hash Join (cost=2.25..9.02 rows=104 width=11) (actual time=0.121..0.121 rows=0 loops=1)

  • Hash Cond: (mm.supplier_contract_id = l.supplier_contract_id)
5. 0.043 0.043 ↑ 1.0 198 1

Seq Scan on money_movement mm (cost=0.00..4.98 rows=198 width=11) (actual time=0.018..0.043 rows=198 loops=1)

6. 0.008 0.040 ↑ 25.0 4 1

Hash (cost=1.00..1.00 rows=100 width=4) (actual time=0.040..0.040 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.032 0.032 ↑ 25.0 4 1

Function Scan on jsonb_to_recordset l (cost=0.00..1.00 rows=100 width=4) (actual time=0.032..0.032 rows=4 loops=1)

8. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.96..2.96 rows=96 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on document_edition de (cost=0.00..2.96 rows=96 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Hash (cost=15.40..15.40 rows=540 width=122) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on document_type dt2 (cost=0.00..15.40 rows=540 width=122) (never executed)