explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q3M6

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.136 ↑ 3,300.0 1 1

Nested Loop (cost=2.81..213.96 rows=3,300 width=71) (actual time=0.132..0.136 rows=1 loops=1)

2. 0.002 0.127 ↑ 100.0 1 1

Nested Loop (cost=2.81..14.45 rows=100 width=103) (actual time=0.124..0.127 rows=1 loops=1)

3. 0.031 0.031 ↑ 1.0 1 1

Index Scan using audits_pkey on audits a (cost=0.55..8.56 rows=1 width=102) (actual time=0.030..0.031 rows=1 loops=1)

  • Index Cond: (id = ANY ('{audit_5a3486e8f110499d97c7f56325077592}'::text[]))
4. 0.012 0.094 ↑ 100.0 1 1

Hash Join (cost=2.26..4.89 rows=100 width=64) (actual time=0.092..0.094 rows=1 loops=1)

  • Hash Cond: (rs.fid = ((i.value -> 'options'::text) ->> 'response_set'::text))
5. 0.049 0.049 ↑ 20.0 5 1

Function Scan on jsonb_each rs (cost=0.01..1.01 rows=100 width=64) (actual time=0.048..0.049 rows=5 loops=1)

6. 0.006 0.033 ↑ 100.0 1 1

Hash (cost=1.00..1.00 rows=100 width=32) (actual time=0.033..0.033 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.027 0.027 ↑ 50.0 2 1

Function Scan on jsonb_array_elements i (cost=0.01..1.00 rows=100 width=32) (actual time=0.027..0.027 rows=2 loops=1)

8. 0.006 0.006 ↑ 33.0 1 1

Function Scan on jsonb_array_elements x (cost=0.01..1.50 rows=33 width=0) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: ((value -> 'failed'::text))::boolean
  • Rows Removed by Filter: 2
Planning time : 0.160 ms
Execution time : 0.186 ms