explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pFHcY

Settings
# exclusive inclusive rows x rows loops node
1. 1,481.025 1,546.667 ↓ 0.0 0 1

Update on public.t271_oppdim t1 (cost=1.13..476,408.27 rows=176,072 width=739) (actual time=1,546.667..1,546.667 rows=0 loops=1)

2. 0.530 65.642 ↑ 258.9 680 1

Nested Loop (cost=1.13..476,408.27 rows=176,072 width=739) (actual time=0.037..65.642 rows=680 loops=1)

  • Output: t1.vid, t1.sid, t1.start_stamp, t1.end_stamp, t1.load_stamp, t1.load_id, t1.source_id, t1.field_info, t1.uncertainty_duration, t1.first, t1.deleted, t1.next_history_field_change_stamp, t1.c964_nid, t1.c965_accountid, t1.c966_accountidnid, t1.c967_name, t
3. 56.663 56.663 ↑ 15.1 71 1

Index Scan using t271_oppdim_sidendstampunique on public.t271_oppdim t2 (cost=0.56..4,414.98 rows=1,070 width=108) (actual time=0.018..56.663 rows=71 loops=1)

  • Output: t2.c985_type, t2.c986_typesid, t2.c990_nextstep, t2.ctid, t2.sid
  • Index Cond: ((t2.sid = ANY ('{2323,43,123,54333,2322,32,6545,6576,12,3445,355,8768,232,543,877,473,2765,9876,6543,322,987,10,99,44,22,777,888,222,333,999,5920,3719,29209,7234,54322,87444,2383,49,113,55333,2522,62,6645,6976,1211,3345,455,8668,212,593,837,49
4. 8.449 8.449 ↑ 11.5 10 71

Index Scan using t271_oppdim_sidendstampunique on public.t271_oppdim t1 (cost=0.56..439.97 rows=115 width=635) (actual time=0.083..0.119 rows=10 loops=71)

  • Output: t1.vid, t1.sid, t1.start_stamp, t1.end_stamp, t1.load_stamp, t1.load_id, t1.source_id, t1.field_info, t1.uncertainty_duration, t1.first, t1.deleted, t1.next_history_field_change_stamp, t1.c964_nid, t1.c965_accountid, t1.c966_accountidnid, t1.c967_n
  • Index Cond: (t1.sid = t2.sid)
Planning time : 3.729 ms
Execution time : 1,546.773 ms