explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ldXU

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.243 ↑ 1.0 300 1

Limit (cost=0.44..491.46 rows=300 width=8) (actual time=0.041..0.243 rows=300 loops=1)

2. 0.016 0.232 ↑ 181.0 300 1

Nested Loop (cost=0.44..88,867.97 rows=54,295 width=8) (actual time=0.040..0.232 rows=300 loops=1)

3. 0.002 0.024 ↑ 1.0 1 1

Nested Loop (cost=0.00..7.59 rows=1 width=8) (actual time=0.024..0.024 rows=1 loops=1)

  • Join Filter: (v.document_master_id = m.id)
  • Rows Removed by Join Filter: 2
4. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on document_master m (cost=0.00..1.64 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=1)

  • Filter: ((name)::text = 'General User Agreement-DE'::text)
  • Rows Removed by Filter: 63
5. 0.006 0.006 ↑ 19.3 3 1

Seq Scan on document_version v (cost=0.00..5.22 rows=58 width=16) (actual time=0.006..0.006 rows=3 loops=1)

  • Filter: (version < 2)
  • Rows Removed by Filter: 5
6. 0.192 0.192 ↑ 269.8 300 1

Index Scan using consent_i on consent c (cost=0.44..88,051.04 rows=80,934 width=16) (actual time=0.015..0.192 rows=300 loops=1)

  • Index Cond: (document_version_id = v.id)
  • Filter: ((status)::text = 'ACCEPTED'::text)
Planning time : 0.465 ms
Execution time : 0.277 ms