explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dY4a

Settings
# exclusive inclusive rows x rows loops node
1. 8,206.252 23,035.425 ↑ 1.0 5,406,907 1

Merge Join (cost=12.52..334,658.15 rows=5,460,271 width=48) (actual time=0.067..23,035.425 rows=5,406,907 loops=1)

  • Merge Cond: (e.docactionrequestid = "e.DocActionRequest".id)
2. 8,010.942 8,010.942 ↑ 1.0 6,184,159 1

Index Scan using ix_docunits_docactionrequestid on docunits e (cost=0.44..263,099.13 rows=6,214,740 width=48) (actual time=0.028..8,010.942 rows=6,184,159 loops=1)

  • Index Cond: (docactionrequestid IS NOT NULL)
  • Filter: (id > 2)
3. 6,818.231 6,818.231 ↑ 1.0 2,704,764 1

Index Scan using docactionrequests_pkey on docactionrequests "e.DocActionRequest" (cost=0.43..128,169.10 rows=2,719,644 width=4) (actual time=0.026..6,818.231 rows=2,704,764 loops=1)

  • Filter: (type = 13)
  • Rows Removed by Filter: 388631