explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GoJM

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 3.930 ↑ 1.0 200 1

Limit (cost=0.42..54.33 rows=200 width=137) (actual time=3.028..3.930 rows=200 loops=1)

2. 0.272 3.917 ↑ 2,325.8 200 1

Nested Loop (cost=0.42..125,375.99 rows=465,160 width=137) (actual time=3.026..3.917 rows=200 loops=1)

3. 3.645 3.645 ↑ 2,325.8 200 1

Index Scan using tb_pivot_news_id_contract_dh_news_idx on tb_pivot_news (cost=0.42..118,397.56 rows=465,160 width=97) (actual time=3.000..3.645 rows=200 loops=1)

  • Index Cond: (id_contract = 8)
  • Filter: (id_agency = 2)
4. 0.000 0.000 ↑ 1.0 1 200

Materialize (cost=0.00..1.03 rows=1 width=20) (actual time=0.000..0.000 rows=1 loops=200)

5. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on tb_pivot_news_agency (cost=0.00..1.03 rows=1 width=20) (actual time=0.008..0.008 rows=1 loops=1)

  • Filter: ((id_contract = 8) AND (id_agency = 2))
  • Rows Removed by Filter: 1