explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GTNI : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 3.794 ↑ 1.0 45 1

Limit (cost=0.87..1,016.72 rows=45 width=680) (actual time=0.033..3.794 rows=45 loops=1)

2. 0.000 3.781 ↑ 4,810.6 45 1

Nested Loop (cost=0.87..4,886,853.87 rows=216,476 width=680) (actual time=0.032..3.781 rows=45 loops=1)

3. 0.078 3.646 ↑ 8,680.0 45 1

Nested Loop (cost=0.43..3,827,061.51 rows=390,599 width=8) (actual time=0.025..3.646 rows=45 loops=1)

4. 3.264 3.264 ↑ 5,396.0 152 1

Seq Scan on teaser_country_relation (cost=0.00..1,339,127.86 rows=820,186 width=4) (actual time=0.015..3.264 rows=152 loops=1)

  • Filter: (country_id = ANY ('{3,67}'::integer[]))
  • Rows Removed by Filter: 28970
5. 0.304 0.304 ↓ 0.0 0 152

Index Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..3.02 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=152)

  • Index Cond: (teaser_id = teaser_country_relation.teaser_id)
  • Filter: (network_id = ANY ('{13,3}'::integer[]))
  • Rows Removed by Filter: 2
6. 0.135 0.135 ↑ 1.0 1 45

Index Scan using teaser_pkey on teaser (cost=0.43..2.70 rows=1 width=680) (actual time=0.002..0.003 rows=1 loops=45)

  • Index Cond: (id = teaser_network_relation.teaser_id)