explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHly

Settings
# exclusive inclusive rows x rows loops node
1. 16.300 156.945 ↓ 1.0 85,201 1

Unique (cost=15,077.50..16,355.71 rows=83,221 width=89) (actual time=115.402..156.945 rows=85,201 loops=1)

2. 78.974 140.645 ↑ 1.0 85,214 1

Sort (cost=15,077.50..15,290.54 rows=85,214 width=89) (actual time=115.401..140.645 rows=85,214 loops=1)

  • Sort Key: a.id, b.identifier_id, b.valid_since DESC, b.status DESC, b.identifier_value
  • Sort Method: external merge Disk: 9320kB
3. 14.986 61.671 ↑ 1.0 85,214 1

Hash Join (cost=920.29..3,727.48 rows=85,214 width=89) (actual time=7.481..61.671 rows=85,214 loops=1)

  • Hash Cond: (b.identifier_id = c.id)
4. 26.192 46.676 ↑ 1.0 85,214 1

Hash Join (cost=871.36..3,454.33 rows=85,214 width=82) (actual time=7.466..46.676 rows=85,214 loops=1)

  • Hash Cond: (b.security_id = a.id)
5. 13.057 13.057 ↑ 1.0 85,214 1

Seq Scan on i_security_reference b (cost=0.00..2,359.24 rows=85,214 width=32) (actual time=0.005..13.057 rows=85,214 loops=1)

  • Filter: ((provider_id = 3) AND (identifier_id = ANY ('{1,4,6,7}'::integer[])))
6. 3.947 7.427 ↑ 1.0 24,505 1

Hash (cost=565.05..565.05 rows=24,505 width=50) (actual time=7.426..7.427 rows=24,505 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 2307kB
7. 3.480 3.480 ↑ 1.0 24,505 1

Seq Scan on m_security a (cost=0.00..565.05 rows=24,505 width=50) (actual time=0.003..3.480 rows=24,505 loops=1)

8. 0.003 0.009 ↑ 216.2 8 1

Hash (cost=27.30..27.30 rows=1,730 width=11) (actual time=0.009..0.009 rows=8 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
9. 0.006 0.006 ↑ 216.2 8 1

Seq Scan on m_identifier c (cost=0.00..27.30 rows=1,730 width=11) (actual time=0.005..0.006 rows=8 loops=1)