explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PUHj

Settings
# exclusive inclusive rows x rows loops node
1. 13.256 57,373.594 ↓ 6.7 6,159 1

Nested Loop (cost=107.80..24,694.72 rows=915 width=6) (actual time=14.666..57,373.594 rows=6,159 loops=1)

2. 57,145.019 57,150.932 ↓ 6.7 6,159 1

Bitmap Heap Scan on settlement_items si (cost=107.36..18,803.25 rows=915 width=8) (actual time=14.608..57,150.932 rows=6,159 loops=1)

  • Recheck Cond: (supplier_id = 106730)
  • Filter: ((order_date >= '2019-02-11 14:26:25.273'::timestamp without time zone) AND (order_date <= '2019-03-13 14:26:25.273'::timestamp without time zone) AND (transaction_type_id = 1))
  • Rows Removed by Filter: 18970
  • Heap Blocks: exact=24532
3. 5.913 5.913 ↓ 3.8 25,258 1

Bitmap Index Scan on idx_settlement_items_supplier_id (cost=0.00..107.13 rows=6,626 width=0) (actual time=5.913..5.913 rows=25,258 loops=1)

  • Index Cond: (supplier_id = 106730)
4. 209.406 209.406 ↑ 1.0 1 6,159

Index Scan using pk_settlement_item_payment on settlement_item_payment sip (cost=0.44..6.43 rows=1 width=14) (actual time=0.033..0.034 rows=1 loops=6,159)

  • Index Cond: (id = si.settlement_item_payment_id)
Planning time : 5.119 ms
Execution time : 57,375.811 ms