explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGex

Settings
# exclusive inclusive rows x rows loops node
1. 28.690 252.058 ↑ 2.0 11,939 1

Hash Join (cost=219.79..56,320.60 rows=23,507 width=1,701) (actual time=57.730..252.058 rows=11,939 loops=1)

  • Hash Cond: (f.flight_group_key = p.flight_group_key)
2. 165.678 165.678 ↑ 20.8 4,191 1

Seq Scan on flights_all f (cost=0.00..54,633.79 rows=87,064 width=776) (actual time=0.006..165.678 rows=4,191 loops=1)

  • Filter: ((NOT d3pf) AND (seats >= 2))
  • Rows Removed by Filter: 480674
3. 16.188 57.690 ↓ 427.9 23,109 1

Hash (cost=219.11..219.11 rows=54 width=937) (actual time=57.690..57.690 rows=23,109 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 7252kB
4. 37.239 41.502 ↓ 427.9 23,109 1

Bitmap Heap Scan on prices_0000_updates p (cost=5.11..219.11 rows=54 width=937) (actual time=6.676..41.502 rows=23,109 loops=1)

  • Recheck Cond: ((modified_date = '2019-02-04 12:52:12'::timestamp without time zone) AND (party_size = '2000'::smallint))
  • Heap Blocks: exact=14355
5. 4.263 4.263 ↓ 427.9 23,109 1

Bitmap Index Scan on ix_brew_prices_0000_updates (cost=0.00..5.09 rows=54 width=0) (actual time=4.263..4.263 rows=23,109 loops=1)

  • Index Cond: ((modified_date = '2019-02-04 12:52:12'::timestamp without time zone) AND (party_size = '2000'::smallint))