explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4rao

Settings
# exclusive inclusive rows x rows loops node
1. 0.405 1,592.394 ↑ 1.0 20 1

Limit (cost=9,225.92..9,225.97 rows=20 width=45) (actual time=1,591.853..1,592.394 rows=20 loops=1)

2. 358.754 1,591.989 ↑ 1,142.5 20 1

Sort (cost=9,225.92..9,283.05 rows=22,851 width=45) (actual time=1,591.839..1,591.989 rows=20 loops=1)

  • Sort Key: flight_flightstatuslog.committed_on DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 827.900 1,233.235 ↓ 2.0 46,149 1

Bitmap Heap Scan on flight_flightstatuslog (cost=3,891.11..8,617.86 rows=22,851 width=45) (actual time=11.260..1,233.235 rows=46,149 loops=1)

  • Recheck Cond: (((commit_type)::text = 'flightlog.ActualDateTimeCommit'::text) OR ((commit_type)::text = 'flight.DiversionTypeCommit'::text) OR ((commit_type)::text = 'flightlog.ActualAirportCommit'::text))
  • Filter: ((((commit_type)::text = 'flightlog.ActualDateTimeCommit'::text) AND (hashed SubPlan 1)) OR (((commit_type)::text = 'flight.DiversionTypeCommit'::text) AND (hashed SubPlan 2)) OR (((commit_type)::text = 'flightlog.ActualAirportCommit'::text) AND (hashed SubPlan 3)))
  • Heap Blocks: exact=434
4. 0.000 5.255 ↓ 0.0 0 1

BitmapOr (cost=2,737.52..2,737.52 rows=45,750 width=0) (actual time=5.241..5.255 rows=0 loops=1)

5. 5.127 5.127 ↓ 1.0 45,733 1

Bitmap Index Scan on flight_flig_commit__ee3854_idx (cost=0.00..2,692.24 rows=45,309 width=0) (actual time=5.107..5.127 rows=45,733 loops=1)

  • Index Cond: ((commit_type)::text = 'flightlog.ActualDateTimeCommit'::text)
6. 0.092 0.092 ↑ 1.1 356 1

Bitmap Index Scan on flight_flig_commit__ee3854_idx (cost=0.00..23.26 rows=379 width=0) (actual time=0.078..0.092 rows=356 loops=1)

  • Index Cond: ((commit_type)::text = 'flight.DiversionTypeCommit'::text)
7. 0.040 0.040 ↑ 1.0 60 1

Bitmap Index Scan on flight_flig_commit__ee3854_idx (cost=0.00..4.88 rows=62 width=0) (actual time=0.026..0.040 rows=60 loops=1)

  • Index Cond: ((commit_type)::text = 'flightlog.ActualAirportCommit'::text)
8.          

SubPlan (forBitmap Heap Scan)

9. 396.766 396.766 ↑ 1.0 50,111 1

Seq Scan on flightlog_actualdatetimecommit u0 (cost=0.00..1,018.11 rows=50,111 width=4) (actual time=0.019..396.766 rows=50,111 loops=1)

  • Filter: reviewed
10. 2.834 2.834 ↑ 1.0 356 1

Seq Scan on flight_diversiontypecommit u0_1 (cost=0.00..7.56 rows=356 width=4) (actual time=0.018..2.834 rows=356 loops=1)

  • Filter: reviewed
11. 0.480 0.480 ↑ 1.0 60 1

Seq Scan on flightlog_actualairportcommit u0_2 (cost=0.00..1.60 rows=60 width=4) (actual time=0.018..0.480 rows=60 loops=1)

  • Filter: reviewed