explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lnog

Settings
# exclusive inclusive rows x rows loops node
1. 13,860.797 30,063.332 ↑ 1.0 5,406,907 1

Hash Join (cost=123,327.41..456,570.30 rows=5,460,271 width=48) (actual time=4,358.324..30,063.332 rows=5,406,907 loops=1)

  • Hash Cond: (e.docactionrequestid = "e.DocActionRequest".id)
2. 11,889.277 11,889.277 ↑ 1.0 6,184,161 1

Seq Scan on docunits e (cost=0.00..197,061.18 rows=6,214,740 width=48) (actual time=9.494..11,889.277 rows=6,184,161 loops=1)

  • Filter: (docactionrequestid IS NOT NULL)
  • Rows Removed by Filter: 4146274
3. 1,700.737 4,313.258 ↑ 1.0 2,704,764 1

Hash (cost=78,707.86..78,707.86 rows=2,719,644 width=4) (actual time=4,313.257..4,313.258 rows=2,704,764 loops=1)

  • Buckets: 131072 Batches: 64 Memory Usage: 2522kB
4. 2,612.521 2,612.521 ↑ 1.0 2,704,764 1

Seq Scan on docactionrequests "e.DocActionRequest" (cost=0.00..78,707.86 rows=2,719,644 width=4) (actual time=0.061..2,612.521 rows=2,704,764 loops=1)

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