explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QpMS5

Settings
# exclusive inclusive rows x rows loops node
1. 8,150.214 19,757.010 ↑ 1.0 5,406,907 1

Merge Join (cost=11.82..325,091.49 rows=5,455,474 width=48) (actual time=0.059..19,757.010 rows=5,406,907 loops=1)

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

Index Scan using ix_docunits_docactionrequestid on docunits e (cost=0.44..247,186.73 rows=6,209,280 width=48) (actual time=0.029..6,530.742 rows=6,184,159 loops=1)

  • Index Cond: (docactionrequestid IS NOT NULL)
3. 5,076.054 5,076.054 ↑ 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.023..5,076.054 rows=2,704,764 loops=1)

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