explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UeG9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

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

2. 0.000 0.000 ↓ 0.0

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

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.00..46,426,797.02 rows=258,575 width=180) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

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

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 rows= loops=)

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