explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PbgH

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.071 ↓ 0.0 0 1

GroupAggregate (cost=879.16..881.76 rows=104 width=158) (actual time=0.071..0.071 rows=0 loops=1)

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

Sort (cost=879.16..879.42 rows=104 width=129) (actual time=0.070..0.070 rows=0 loops=1)

  • Sort Key: dt2.doc_type_name, de.doc_type_id, mm.supplier_contract_id
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.061 ↓ 0.0 0 1

Hash Join (cost=26.74..875.68 rows=104 width=129) (actual time=0.061..0.061 rows=0 loops=1)

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

Hash Join (cost=4.59..852.22 rows=104 width=11) (actual time=0.061..0.061 rows=0 loops=1)

  • Hash Cond: (mm.doc_edit_id = de.doc_edit_id)
5. 0.005 0.060 ↓ 0.0 0 1

Nested Loop (cost=0.43..846.75 rows=104 width=11) (actual time=0.060..0.060 rows=0 loops=1)

6. 0.027 0.027 ↑ 25.0 4 1

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

7. 0.028 0.028 ↓ 0.0 0 4

Index Scan using idx_money_movement_supplier_contract_id on money_movement mm (cost=0.43..8.45 rows=1 width=11) (actual time=0.007..0.007 rows=0 loops=4)

  • Index Cond: (supplier_contract_id = l.supplier_contract_id)
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)