explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XeWf

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 2.818 ↑ 1.0 200 1

Limit (cost=1.7..571.5 rows=200 width=1,131) (actual time=0.043..2.818 rows=200 loops=1)

  • Buffers: shared hit=1006 read=107
2. 0.281 2.797 ↑ 1,335.9 200 1

Nested Loop (cost=1.7..761,186.7 rows=267,174 width=1,131) (actual time=0.043..2.797 rows=200 loops=1)

  • Buffers: shared hit=1006 read=107
3. 0.130 2.316 ↑ 1,335.9 200 1

Nested Loop (cost=1.27..625,268.78 rows=267,174 width=824) (actual time=0.034..2.316 rows=200 loops=1)

  • Buffers: shared hit=721 read=104
4. 0.105 0.786 ↑ 1,335.9 200 1

Nested Loop (cost=0.85..371,172.61 rows=267,174 width=585) (actual time=0.033..0.786 rows=200 loops=1)

  • Buffers: shared hit=149 read=23
5. 0.103 0.681 ↑ 1,335.9 200 1

Nested Loop (cost=0.42..210,046.48 rows=267,174 width=342) (actual time=0.032..0.681 rows=200 loops=1)

  • Buffers: shared hit=141 read=23
6. 0.178 0.178 ↑ 1,335.9 200 1

Seq Scan on contragent_supplier contragent_supplier (cost=0..51,066.18 rows=267,174 width=163) (actual time=0.016..0.178 rows=200 loops=1)

  • Filter: ((contragent_supplier.ent_id IS NULL) AND (contragent_supplier.begin <= '2019-08-05'::date) AND ((contragent_supplier."end" >= '2019-08-05'::date) OR (contragent_supplier."end" IS NULL)))
  • Buffers: shared hit=16
7. 0.400 0.400 ↓ 0.0 0 200

Index Scan using contragent_person_pkey on contragent_person contragent_person (cost=0.42..0.59 rows=1 width=179) (actual time=0.002..0.002 rows=0 loops=200)

  • Index Cond: (contragent_supplier.person_id = contragent_person.id)
  • Buffers: shared hit=125 read=23
8. 0.000 0.000 ↓ 0.0 0 200

Index Scan using contragent_address_pkey on contragent_address contragent_address (cost=0.42..0.59 rows=1 width=243) (actual time=0..0 rows=0 loops=200)

  • Index Cond: (contragent_person.entrepreneur_ur_address_id = contragent_address.id)
  • Buffers: shared hit=8
9. 1.400 1.400 ↑ 1.0 1 200

Index Scan using contragent_corporation_pkey on contragent_corporation contragent_corporation (cost=0.43..0.94 rows=1 width=239) (actual time=0.007..0.007 rows=1 loops=200)

  • Index Cond: (contragent_supplier.corporation_id = contragent_corporation.id)
  • Buffers: shared hit=572 read=81
10. 0.200 0.200 ↓ 0.0 0 200

Index Scan using contragent_address_pkey on contragent_address t5 (cost=0.42..0.49 rows=1 width=243) (actual time=0.001..0.001 rows=0 loops=200)

  • Index Cond: (contragent_corporation.ur_address_id = t5.id)
  • Buffers: shared hit=285 read=3