explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m2TY

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

Nested Loop (cost=2.13..11,461.70 rows=1 width=71) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..11,460.68 rows=1 width=83) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..11,347.16 rows=137 width=62) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using usr_orgid_id_idx on usr u (cost=0.42..32.56 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (org_id = 65)
  • Filter: (group_id = 2)
5. 0.000 0.000 ↓ 0.0

Index Scan using dc_executor_idx on document_control dc (cost=0.57..11,283.01 rows=3,159 width=56) (actual rows= loops=)

  • Index Cond: (executor = u.id)
  • Filter: (g_mtime <= '2019-10-02 00:00:00'::timestamp without time zone)
6. 0.000 0.000 ↓ 0.0

Index Scan using document_n_uniq_idx on document_n dn (cost=0.57..0.82 rows=1 width=29) (actual rows= loops=)

  • Index Cond: ((document_id = dc.document_id) AND (org_id = 2))
  • Filter: ((rdate >= '2018-10-01 00:00:00'::timestamp without time zone) AND (rdate <= '2019-10-01 00:00:00'::timestamp without time zone) AND (status = 8) AND (d_deleted = 0))
7. 0.000 0.000 ↓ 0.0

Index Scan using sys_c0014909 on resolution_to rt (cost=0.57..0.99 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = dc.resolution_to_id)
  • Filter: (another_control = 1)