explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qde

Settings
# exclusive inclusive rows x rows loops node
1. 38.384 5,646.520 ↓ 3.0 492,089 1

Limit (cost=166.11..78,700.09 rows=164,380 width=177) (actual time=25.434..5,646.520 rows=492,089 loops=1)

2. 170.611 5,608.136 ↓ 3.0 492,089 1

Hash Join (cost=166.11..78,700.09 rows=164,380 width=177) (actual time=25.433..5,608.136 rows=492,089 loops=1)

  • Hash Cond: ((offerdatae0_.brochure_data_id)::text = (brochureda1_.id)::text)
3. 5,413.564 5,413.564 ↓ 1.0 492,089 1

Seq Scan on offer_data offerdatae0_ (cost=0.00..75,045.13 rows=492,013 width=177) (actual time=0.575..5,413.564 rows=492,089 loops=1)

4. 0.967 23.961 ↓ 3.0 437 1

Hash (cost=164.29..164.29 rows=146 width=37) (actual time=23.961..23.961 rows=437 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 38kB
5. 0.000 22.994 ↓ 3.0 437 1

Nested Loop (cost=149.59..164.29 rows=146 width=37) (actual time=20.711..22.994 rows=437 loops=1)

6. 0.042 20.883 ↓ 437.0 437 1

Nested Loop (cost=149.32..160.26 rows=1 width=127) (actual time=20.682..20.883 rows=437 loops=1)

7. 0.014 0.014 ↑ 1.0 1 1

Index Only Scan using flight_data_pk on flight_data flightdata2_ (cost=0.14..8.15 rows=1 width=90) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (id = 'eada8181-c86b-45c4-aad5-5e6b2dafad39'::text)
  • Heap Fetches: 1
8. 1.680 20.827 ↓ 3.0 437 1

HashAggregate (cost=149.18..150.64 rows=146 width=37) (actual time=20.668..20.827 rows=437 loops=1)

  • Group Key: (br.brochure_id)::text
9. 0.071 19.147 ↓ 3.0 437 1

Nested Loop (cost=0.14..148.82 rows=146 width=37) (actual time=0.590..19.147 rows=437 loops=1)

10. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using flight_data_pk on flight_data fd (cost=0.14..8.15 rows=1 width=90) (actual time=0.001..0.003 rows=1 loops=1)

  • Index Cond: (id = 'eada8181-c86b-45c4-aad5-5e6b2dafad39'::text)
  • Heap Fetches: 1
11. 19.073 19.073 ↓ 3.0 437 1

Seq Scan on brochure_data br (cost=0.00..139.20 rows=146 width=74) (actual time=0.587..19.073 rows=437 loops=1)

  • Filter: (((flight_data_id)::text = 'eada8181-c86b-45c4-aad5-5e6b2dafad39'::text) AND (to_timestamp(((((data ->> 'publicationEndDate'::text))::bigint / 1000))::double precision) > now()))
12. 2.185 2.185 ↑ 1.0 1 437

Index Scan using brochure_data_brochure_id_date_created_idx on brochure_data brochureda1_ (cost=0.27..4.02 rows=1 width=111) (actual time=0.004..0.005 rows=1 loops=437)

  • Index Cond: ((brochure_id)::text = (br.brochure_id)::text)
  • Filter: ((flight_data_id)::text = 'eada8181-c86b-45c4-aad5-5e6b2dafad39'::text)
Planning time : 10.214 ms
Execution time : 5,674.996 ms