explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YgBq

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 22,283.806 ↓ 0.0 0 1

Nested Loop (cost=59,914.78..157,617.42 rows=1,040 width=286) (actual time=22,283.806..22,283.806 rows=0 loops=1)

  • Join Filter: (trip_ledgers.id <> advanced_trips.trip_ledger_id)
2.          

CTE advanced_trips

3. 22,270.850 22,283.804 ↓ 0.0 0 1

Bitmap Heap Scan on trip_ledger_items (cost=593.33..58,914.78 rows=4 width=4) (actual time=22,283.804..22,283.804 rows=0 loops=1)

  • Recheck Cond: ((type)::text = 'TripLedgerItem::AdvancedCreditItem'::text)
  • Filter: (created_at >= '2019-10-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 52,508
  • Heap Blocks: exact=42,813
4. 12.954 12.954 ↓ 1.2 52,508 1

Bitmap Index Scan on index_trip_ledger_items_on_type (cost=0.00..593.33 rows=43,477 width=0) (actual time=12.954..12.954 rows=52,508 loops=1)

  • Index Cond: ((type)::text = 'TripLedgerItem::AdvancedCreditItem'::text)
5. 22,283.805 22,283.805 ↓ 0.0 0 1

CTE Scan on advanced_trips (cost=0.00..0.02 rows=4 width=4) (actual time=22,283.805..22,283.805 rows=0 loops=1)

6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=1,000.00..98,698.59 rows=260 width=282) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..98,698.33 rows=260 width=282) (never executed)

  • Workers Planned: 4
  • Workers Launched: 0
8. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on trip_ledgers (cost=0.00..97,672.33 rows=65 width=282) (never executed)

  • Filter: (created_at >= '2019-10-02 00:00:00'::timestamp without time zone)