explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRKY

Settings
# exclusive inclusive rows x rows loops node
1. 0.270 652.315 ↑ 1.4 1,783 1

Unique (cost=165,103.31..165,115.94 rows=2,526 width=82) (actual time=651.917..652.315 rows=1,783 loops=1)

2. 23.219 652.045 ↑ 1.4 1,783 1

Sort (cost=165,103.31..165,109.62 rows=2,526 width=82) (actual time=651.917..652.045 rows=1,783 loops=1)

  • Sort Key: pr4_rule_vw.pzinskey
  • Sort Method: quicksort Memory: 324kB
3. 0.584 628.826 ↑ 1.4 1,783 1

Nested Loop (cost=161,245.39..164,960.56 rows=2,526 width=82) (actual time=592.337..628.826 rows=1,783 loops=1)

4. 0.783 592.582 ↑ 1.4 1,783 1

HashAggregate (cost=161,244.85..161,270.11 rows=2,526 width=87) (actual time=592.303..592.582 rows=1,783 loops=1)

  • Group Key: ("ANY_subquery".pzinskey)::text
5. 0.193 591.799 ↑ 1.4 1,783 1

Subquery Scan on ANY_subquery (cost=161,200.15..161,238.53 rows=2,526 width=87) (actual time=590.932..591.799 rows=1,783 loops=1)

6. 0.428 591.606 ↑ 1.4 1,783 1

Unique (cost=161,200.15..161,213.27 rows=2,526 width=87) (actual time=590.931..591.606 rows=1,783 loops=1)

7. 4.267 591.178 ↓ 1.5 3,930 1

Sort (cost=161,200.15..161,206.71 rows=2,625 width=87) (actual time=590.930..591.178 rows=3,930 loops=1)

  • Sort Key: pr_index_reference.pxinsindexedkey
  • Sort Method: quicksort Memory: 733kB
8. 586.911 586.911 ↓ 1.5 3,930 1

Index Scan using index_ref on pr_index_reference (cost=0.55..161,051.07 rows=2,625 width=87) (actual time=6.460..586.911 rows=3,930 loops=1)

  • Index Cond: ((pxinsindexedkey)::text > 'RULE-OBJ-LISTVIEW WB-FW-WBHE-WORK SCAPROCESSEDWORKLIST!ALL #20140205T214734.076 GMT'::text)
  • Filter: ((pxpagename IS NOT NULL) AND ((pxreferencingrulesetname)::text !~~ 'Pega-%'::text))
  • Rows Removed by Filter: 415552
9. 35.660 35.660 ↑ 1.0 1 1,783

Index Only Scan using pr4_rule_vw_pk on pr4_rule_vw (cost=0.55..1.45 rows=1 width=82) (actual time=0.020..0.020 rows=1 loops=1,783)

  • Index Cond: (pzinskey = ("ANY_subquery".pzinskey)::text)
  • Heap Fetches: 0