explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tiF9

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 65,595.277 ↓ 0.0 0 1

Limit (cost=0.99..198.01 rows=100 width=1,920) (actual time=65,595.277..65,595.277 rows=0 loops=1)

2. 456.145 65,595.275 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.99..1,016,855.84 rows=516,126 width=1,920) (actual time=65,595.275..65,595.275 rows=0 loops=1)

3. 152.169 60,011.420 ↑ 1.0 1,025,542 1

Merge Append (cost=0.44..244,729.40 rows=1,032,252 width=1,920) (actual time=1.205..60,011.420 rows=1,025,542 loops=1)

  • Sort Key: parent_request_20191124.create_date DESC
4. 59,859.251 59,859.251 ↑ 1.0 1,025,542 1

Index Scan Backward using i_parent_request_20191124_create_date on parent_request_20191124 (cost=0.43..236,987.50 rows=1,032,252 width=1,920) (actual time=1.204..59,859.251 rows=1,025,542 loops=1)

  • Index Cond: ((create_date >= '2019-11-24 02:00:00'::timestamp without time zone) AND (create_date <= '2019-11-24 18:00:00'::timestamp without time zone))
  • Filter: ((record_date >= '2019-11-24'::date) AND (record_date <= '2019-11-24'::date))
5. 0.000 5,127.710 ↓ 0.0 0 1,025,542

Append (cost=0.56..0.74 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1,025,542)

6. 5,127.710 5,127.710 ↓ 0.0 0 1,025,542

Index Scan using i_request_identity_20191124_payload on request_identity_20191124 (cost=0.56..0.74 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1,025,542)

  • Index Cond: ((parent_c_id = parent_request_20191124.c_id) AND ((identity_name)::text = 'MSISDN'::text) AND ((identity_value)::text = '79222014793'::text))
  • Filter: ((record_date >= '2019-11-24'::date) AND (record_date <= '2019-11-24'::date))
Planning time : 4.806 ms
Execution time : 65,595.380 ms