explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JQUE

Settings
# exclusive inclusive rows x rows loops node
1. 1,781.266 3,653.210 ↓ 0.0 0 1

Hash Join (cost=2.50..132,511.67 rows=1,262 width=674) (actual time=3,653.210..3,653.210 rows=0 loops=1)

  • Hash Cond: (((detail_data.key ->> 'keyId'::text) = (jsonb_to_recordset."keyId")::text) AND ((detail_data.key ->> 'componentId'::text) = (jsonb_to_recordset."componentId")::text))
2. 223.168 1,871.923 ↑ 1.0 495,475 1

Append (cost=0.00..124,922.84 rows=504,914 width=674) (actual time=0.130..1,871.923 rows=495,475 loops=1)

3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on detail_data (cost=0.00..0.00 rows=1 width=1,120) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((business_date = '2019-06-28'::date) AND (stream_id = '1'::smallint) AND ((tag)::text = 'LATEST'::text))
4. 1,648.754 1,648.754 ↑ 1.0 495,475 1

Seq Scan on detail_data_2019_06 (cost=0.00..124,922.84 rows=504,913 width=674) (actual time=0.129..1,648.754 rows=495,475 loops=1)

  • Filter: ((business_date = '2019-06-28'::date) AND (stream_id = '1'::smallint) AND ((tag)::text = 'LATEST'::text))
  • Rows Removed by Filter: 219469
5. 0.007 0.021 ↑ 100.0 1 1

Hash (cost=1.00..1.00 rows=100 width=8) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.014 0.014 ↑ 100.0 1 1

Function Scan on jsonb_to_recordset (cost=0.00..1.00 rows=100 width=8) (actual time=0.013..0.014 rows=1 loops=1)

Planning time : 1.863 ms
Execution time : 3,653.267 ms