explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hDBF : ddddddddddddddd

Settings
# exclusive inclusive rows x rows loops node
1. 16,686.905 25,269.354 ↑ 1.0 45,307,988 1

Nested Loop (cost=0.00..567,901.59 rows=45,315,304 width=8) (actual time=0.034..25,269.354 rows=45,307,988 loops=1)

2. 11.337 11.337 ↑ 1.0 12,386 1

Seq Scan on hn_contract_pay pay (cost=0.00..1,028.34 rows=12,388 width=8) (actual time=0.016..11.337 rows=12,386 loops=1)

  • Filter: (base > 925000)
  • Rows Removed by Filter: 32601
3. 8,567.265 8,571.112 ↑ 1.0 3,658 12,386

Materialize (cost=0.00..441.10 rows=3,658 width=0) (actual time=0.000..0.692 rows=3,658 loops=12,386)

4. 3.847 3.847 ↑ 1.0 3,658 1

Seq Scan on hn_contract con (cost=0.00..422.81 rows=3,658 width=0) (actual time=0.013..3.847 rows=3,658 loops=1)

  • Filter: is_elc
  • Rows Removed by Filter: 17423