explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WHX

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 15.310 ↑ 1.0 45 1

Limit (cost=1,001.03..4,372.75 rows=45 width=180) (actual time=8.954..15.310 rows=45 loops=1)

2. 1.424 15.296 ↑ 13,790.7 45 1

Gather Merge (cost=1,001.03..46,499,427.49 rows=620,581 width=180) (actual time=8.949..15.296 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.607 13.872 ↑ 7,605.1 34 3

Nested Loop (cost=1.00..46,426,797.02 rows=258,575 width=180) (actual time=0.652..4.624 rows=34 loops=3)

4. 1.020 1.020 ↑ 17,350.9 288 3

Parallel Index Scan Backward using teaser_created_at on teaser (cost=0.43..675,013.78 rows=4,997,067 width=180) (actual time=0.059..0.340 rows=288 loops=3)

  • Filter: ((clicks >= '0'::bigint) AND (clicks <= '4000000'::bigint))
5. 11.245 11.245 ↓ 0.0 0 865

Index Only Scan using idx_16500_idx_teaser_country_relation_temp_teaser_id_country_id on teaser_country_relation (cost=0.57..9.14 rows=2 width=8) (actual time=0.013..0.013 rows=0 loops=865)

  • Index Cond: ((teaser_id = teaser.id) AND (country_id = ANY ('{3,67}'::bigint[])))
  • Heap Fetches: 102